package com.tangdi.production.mpaychl.model;

import java.util.ArrayList;
import java.util.List;

public class MpamngAgentInfExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MpamngAgentInfExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andAgentIdIsNull() {
            addCriterion("AGENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andAgentIdIsNotNull() {
            addCriterion("AGENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAgentIdEqualTo(String value) {
            addCriterion("AGENT_ID =", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotEqualTo(String value) {
            addCriterion("AGENT_ID <>", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdGreaterThan(String value) {
            addCriterion("AGENT_ID >", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_ID >=", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLessThan(String value) {
            addCriterion("AGENT_ID <", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLessThanOrEqualTo(String value) {
            addCriterion("AGENT_ID <=", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLike(String value) {
            addCriterion("AGENT_ID like", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotLike(String value) {
            addCriterion("AGENT_ID not like", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdIn(List<String> values) {
            addCriterion("AGENT_ID in", values, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotIn(List<String> values) {
            addCriterion("AGENT_ID not in", values, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdBetween(String value1, String value2) {
            addCriterion("AGENT_ID between", value1, value2, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotBetween(String value1, String value2) {
            addCriterion("AGENT_ID not between", value1, value2, "agentId");
            return (Criteria) this;
        }

        public Criteria andLogonNameIsNull() {
            addCriterion("LOGON_NAME is null");
            return (Criteria) this;
        }

        public Criteria andLogonNameIsNotNull() {
            addCriterion("LOGON_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andLogonNameEqualTo(String value) {
            addCriterion("LOGON_NAME =", value, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameNotEqualTo(String value) {
            addCriterion("LOGON_NAME <>", value, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameGreaterThan(String value) {
            addCriterion("LOGON_NAME >", value, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameGreaterThanOrEqualTo(String value) {
            addCriterion("LOGON_NAME >=", value, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameLessThan(String value) {
            addCriterion("LOGON_NAME <", value, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameLessThanOrEqualTo(String value) {
            addCriterion("LOGON_NAME <=", value, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameLike(String value) {
            addCriterion("LOGON_NAME like", value, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameNotLike(String value) {
            addCriterion("LOGON_NAME not like", value, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameIn(List<String> values) {
            addCriterion("LOGON_NAME in", values, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameNotIn(List<String> values) {
            addCriterion("LOGON_NAME not in", values, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameBetween(String value1, String value2) {
            addCriterion("LOGON_NAME between", value1, value2, "logonName");
            return (Criteria) this;
        }

        public Criteria andLogonNameNotBetween(String value1, String value2) {
            addCriterion("LOGON_NAME not between", value1, value2, "logonName");
            return (Criteria) this;
        }

        public Criteria andAgentDgrIsNull() {
            addCriterion("AGENT_DGR is null");
            return (Criteria) this;
        }

        public Criteria andAgentDgrIsNotNull() {
            addCriterion("AGENT_DGR is not null");
            return (Criteria) this;
        }

        public Criteria andAgentDgrEqualTo(String value) {
            addCriterion("AGENT_DGR =", value, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrNotEqualTo(String value) {
            addCriterion("AGENT_DGR <>", value, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrGreaterThan(String value) {
            addCriterion("AGENT_DGR >", value, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_DGR >=", value, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrLessThan(String value) {
            addCriterion("AGENT_DGR <", value, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrLessThanOrEqualTo(String value) {
            addCriterion("AGENT_DGR <=", value, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrLike(String value) {
            addCriterion("AGENT_DGR like", value, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrNotLike(String value) {
            addCriterion("AGENT_DGR not like", value, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrIn(List<String> values) {
            addCriterion("AGENT_DGR in", values, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrNotIn(List<String> values) {
            addCriterion("AGENT_DGR not in", values, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrBetween(String value1, String value2) {
            addCriterion("AGENT_DGR between", value1, value2, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andAgentDgrNotBetween(String value1, String value2) {
            addCriterion("AGENT_DGR not between", value1, value2, "agentDgr");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdIsNull() {
            addCriterion("FATH_AGENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdIsNotNull() {
            addCriterion("FATH_AGENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdEqualTo(String value) {
            addCriterion("FATH_AGENT_ID =", value, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdNotEqualTo(String value) {
            addCriterion("FATH_AGENT_ID <>", value, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdGreaterThan(String value) {
            addCriterion("FATH_AGENT_ID >", value, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdGreaterThanOrEqualTo(String value) {
            addCriterion("FATH_AGENT_ID >=", value, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdLessThan(String value) {
            addCriterion("FATH_AGENT_ID <", value, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdLessThanOrEqualTo(String value) {
            addCriterion("FATH_AGENT_ID <=", value, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdLike(String value) {
            addCriterion("FATH_AGENT_ID like", value, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdNotLike(String value) {
            addCriterion("FATH_AGENT_ID not like", value, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdIn(List<String> values) {
            addCriterion("FATH_AGENT_ID in", values, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdNotIn(List<String> values) {
            addCriterion("FATH_AGENT_ID not in", values, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdBetween(String value1, String value2) {
            addCriterion("FATH_AGENT_ID between", value1, value2, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFathAgentIdNotBetween(String value1, String value2) {
            addCriterion("FATH_AGENT_ID not between", value1, value2, "fathAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdIsNull() {
            addCriterion("FIRST_AGENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdIsNotNull() {
            addCriterion("FIRST_AGENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdEqualTo(String value) {
            addCriterion("FIRST_AGENT_ID =", value, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdNotEqualTo(String value) {
            addCriterion("FIRST_AGENT_ID <>", value, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdGreaterThan(String value) {
            addCriterion("FIRST_AGENT_ID >", value, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdGreaterThanOrEqualTo(String value) {
            addCriterion("FIRST_AGENT_ID >=", value, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdLessThan(String value) {
            addCriterion("FIRST_AGENT_ID <", value, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdLessThanOrEqualTo(String value) {
            addCriterion("FIRST_AGENT_ID <=", value, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdLike(String value) {
            addCriterion("FIRST_AGENT_ID like", value, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdNotLike(String value) {
            addCriterion("FIRST_AGENT_ID not like", value, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdIn(List<String> values) {
            addCriterion("FIRST_AGENT_ID in", values, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdNotIn(List<String> values) {
            addCriterion("FIRST_AGENT_ID not in", values, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdBetween(String value1, String value2) {
            addCriterion("FIRST_AGENT_ID between", value1, value2, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andFirstAgentIdNotBetween(String value1, String value2) {
            addCriterion("FIRST_AGENT_ID not between", value1, value2, "firstAgentId");
            return (Criteria) this;
        }

        public Criteria andAgentNameIsNull() {
            addCriterion("AGENT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andAgentNameIsNotNull() {
            addCriterion("AGENT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andAgentNameEqualTo(String value) {
            addCriterion("AGENT_NAME =", value, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameNotEqualTo(String value) {
            addCriterion("AGENT_NAME <>", value, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameGreaterThan(String value) {
            addCriterion("AGENT_NAME >", value, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_NAME >=", value, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameLessThan(String value) {
            addCriterion("AGENT_NAME <", value, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameLessThanOrEqualTo(String value) {
            addCriterion("AGENT_NAME <=", value, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameLike(String value) {
            addCriterion("AGENT_NAME like", value, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameNotLike(String value) {
            addCriterion("AGENT_NAME not like", value, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameIn(List<String> values) {
            addCriterion("AGENT_NAME in", values, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameNotIn(List<String> values) {
            addCriterion("AGENT_NAME not in", values, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameBetween(String value1, String value2) {
            addCriterion("AGENT_NAME between", value1, value2, "agentName");
            return (Criteria) this;
        }

        public Criteria andAgentNameNotBetween(String value1, String value2) {
            addCriterion("AGENT_NAME not between", value1, value2, "agentName");
            return (Criteria) this;
        }

        public Criteria andLegalNameIsNull() {
            addCriterion("LEGAL_NAME is null");
            return (Criteria) this;
        }

        public Criteria andLegalNameIsNotNull() {
            addCriterion("LEGAL_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andLegalNameEqualTo(String value) {
            addCriterion("LEGAL_NAME =", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameNotEqualTo(String value) {
            addCriterion("LEGAL_NAME <>", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameGreaterThan(String value) {
            addCriterion("LEGAL_NAME >", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameGreaterThanOrEqualTo(String value) {
            addCriterion("LEGAL_NAME >=", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameLessThan(String value) {
            addCriterion("LEGAL_NAME <", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameLessThanOrEqualTo(String value) {
            addCriterion("LEGAL_NAME <=", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameLike(String value) {
            addCriterion("LEGAL_NAME like", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameNotLike(String value) {
            addCriterion("LEGAL_NAME not like", value, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameIn(List<String> values) {
            addCriterion("LEGAL_NAME in", values, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameNotIn(List<String> values) {
            addCriterion("LEGAL_NAME not in", values, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameBetween(String value1, String value2) {
            addCriterion("LEGAL_NAME between", value1, value2, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalNameNotBetween(String value1, String value2) {
            addCriterion("LEGAL_NAME not between", value1, value2, "legalName");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoIsNull() {
            addCriterion("LEGAL_IDENTITY_NO is null");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoIsNotNull() {
            addCriterion("LEGAL_IDENTITY_NO is not null");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoEqualTo(String value) {
            addCriterion("LEGAL_IDENTITY_NO =", value, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoNotEqualTo(String value) {
            addCriterion("LEGAL_IDENTITY_NO <>", value, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoGreaterThan(String value) {
            addCriterion("LEGAL_IDENTITY_NO >", value, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoGreaterThanOrEqualTo(String value) {
            addCriterion("LEGAL_IDENTITY_NO >=", value, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoLessThan(String value) {
            addCriterion("LEGAL_IDENTITY_NO <", value, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoLessThanOrEqualTo(String value) {
            addCriterion("LEGAL_IDENTITY_NO <=", value, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoLike(String value) {
            addCriterion("LEGAL_IDENTITY_NO like", value, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoNotLike(String value) {
            addCriterion("LEGAL_IDENTITY_NO not like", value, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoIn(List<String> values) {
            addCriterion("LEGAL_IDENTITY_NO in", values, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoNotIn(List<String> values) {
            addCriterion("LEGAL_IDENTITY_NO not in", values, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoBetween(String value1, String value2) {
            addCriterion("LEGAL_IDENTITY_NO between", value1, value2, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityNoNotBetween(String value1, String value2) {
            addCriterion("LEGAL_IDENTITY_NO not between", value1, value2, "legalIdentityNo");
            return (Criteria) this;
        }

        public Criteria andLicNoIsNull() {
            addCriterion("LIC_NO is null");
            return (Criteria) this;
        }

        public Criteria andLicNoIsNotNull() {
            addCriterion("LIC_NO is not null");
            return (Criteria) this;
        }

        public Criteria andLicNoEqualTo(String value) {
            addCriterion("LIC_NO =", value, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoNotEqualTo(String value) {
            addCriterion("LIC_NO <>", value, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoGreaterThan(String value) {
            addCriterion("LIC_NO >", value, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoGreaterThanOrEqualTo(String value) {
            addCriterion("LIC_NO >=", value, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoLessThan(String value) {
            addCriterion("LIC_NO <", value, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoLessThanOrEqualTo(String value) {
            addCriterion("LIC_NO <=", value, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoLike(String value) {
            addCriterion("LIC_NO like", value, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoNotLike(String value) {
            addCriterion("LIC_NO not like", value, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoIn(List<String> values) {
            addCriterion("LIC_NO in", values, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoNotIn(List<String> values) {
            addCriterion("LIC_NO not in", values, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoBetween(String value1, String value2) {
            addCriterion("LIC_NO between", value1, value2, "licNo");
            return (Criteria) this;
        }

        public Criteria andLicNoNotBetween(String value1, String value2) {
            addCriterion("LIC_NO not between", value1, value2, "licNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoIsNull() {
            addCriterion("TAX_NO is null");
            return (Criteria) this;
        }

        public Criteria andTaxNoIsNotNull() {
            addCriterion("TAX_NO is not null");
            return (Criteria) this;
        }

        public Criteria andTaxNoEqualTo(String value) {
            addCriterion("TAX_NO =", value, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoNotEqualTo(String value) {
            addCriterion("TAX_NO <>", value, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoGreaterThan(String value) {
            addCriterion("TAX_NO >", value, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoGreaterThanOrEqualTo(String value) {
            addCriterion("TAX_NO >=", value, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoLessThan(String value) {
            addCriterion("TAX_NO <", value, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoLessThanOrEqualTo(String value) {
            addCriterion("TAX_NO <=", value, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoLike(String value) {
            addCriterion("TAX_NO like", value, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoNotLike(String value) {
            addCriterion("TAX_NO not like", value, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoIn(List<String> values) {
            addCriterion("TAX_NO in", values, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoNotIn(List<String> values) {
            addCriterion("TAX_NO not in", values, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoBetween(String value1, String value2) {
            addCriterion("TAX_NO between", value1, value2, "taxNo");
            return (Criteria) this;
        }

        public Criteria andTaxNoNotBetween(String value1, String value2) {
            addCriterion("TAX_NO not between", value1, value2, "taxNo");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andTelIsNull() {
            addCriterion("TEL is null");
            return (Criteria) this;
        }

        public Criteria andTelIsNotNull() {
            addCriterion("TEL is not null");
            return (Criteria) this;
        }

        public Criteria andTelEqualTo(String value) {
            addCriterion("TEL =", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotEqualTo(String value) {
            addCriterion("TEL <>", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThan(String value) {
            addCriterion("TEL >", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelGreaterThanOrEqualTo(String value) {
            addCriterion("TEL >=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThan(String value) {
            addCriterion("TEL <", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLessThanOrEqualTo(String value) {
            addCriterion("TEL <=", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelLike(String value) {
            addCriterion("TEL like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotLike(String value) {
            addCriterion("TEL not like", value, "tel");
            return (Criteria) this;
        }

        public Criteria andTelIn(List<String> values) {
            addCriterion("TEL in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotIn(List<String> values) {
            addCriterion("TEL not in", values, "tel");
            return (Criteria) this;
        }

        public Criteria andTelBetween(String value1, String value2) {
            addCriterion("TEL between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andTelNotBetween(String value1, String value2) {
            addCriterion("TEL not between", value1, value2, "tel");
            return (Criteria) this;
        }

        public Criteria andMoblieNoIsNull() {
            addCriterion("MOBLIE_NO is null");
            return (Criteria) this;
        }

        public Criteria andMoblieNoIsNotNull() {
            addCriterion("MOBLIE_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMoblieNoEqualTo(String value) {
            addCriterion("MOBLIE_NO =", value, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoNotEqualTo(String value) {
            addCriterion("MOBLIE_NO <>", value, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoGreaterThan(String value) {
            addCriterion("MOBLIE_NO >", value, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoGreaterThanOrEqualTo(String value) {
            addCriterion("MOBLIE_NO >=", value, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoLessThan(String value) {
            addCriterion("MOBLIE_NO <", value, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoLessThanOrEqualTo(String value) {
            addCriterion("MOBLIE_NO <=", value, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoLike(String value) {
            addCriterion("MOBLIE_NO like", value, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoNotLike(String value) {
            addCriterion("MOBLIE_NO not like", value, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoIn(List<String> values) {
            addCriterion("MOBLIE_NO in", values, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoNotIn(List<String> values) {
            addCriterion("MOBLIE_NO not in", values, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoBetween(String value1, String value2) {
            addCriterion("MOBLIE_NO between", value1, value2, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andMoblieNoNotBetween(String value1, String value2) {
            addCriterion("MOBLIE_NO not between", value1, value2, "moblieNo");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("EMAIL is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("EMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("EMAIL =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("EMAIL <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("EMAIL >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("EMAIL <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("EMAIL <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("EMAIL like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("EMAIL not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("EMAIL in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("EMAIL not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("EMAIL between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("EMAIL not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andFrozStateIsNull() {
            addCriterion("FROZ_STATE is null");
            return (Criteria) this;
        }

        public Criteria andFrozStateIsNotNull() {
            addCriterion("FROZ_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andFrozStateEqualTo(String value) {
            addCriterion("FROZ_STATE =", value, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateNotEqualTo(String value) {
            addCriterion("FROZ_STATE <>", value, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateGreaterThan(String value) {
            addCriterion("FROZ_STATE >", value, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateGreaterThanOrEqualTo(String value) {
            addCriterion("FROZ_STATE >=", value, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateLessThan(String value) {
            addCriterion("FROZ_STATE <", value, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateLessThanOrEqualTo(String value) {
            addCriterion("FROZ_STATE <=", value, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateLike(String value) {
            addCriterion("FROZ_STATE like", value, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateNotLike(String value) {
            addCriterion("FROZ_STATE not like", value, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateIn(List<String> values) {
            addCriterion("FROZ_STATE in", values, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateNotIn(List<String> values) {
            addCriterion("FROZ_STATE not in", values, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateBetween(String value1, String value2) {
            addCriterion("FROZ_STATE between", value1, value2, "frozState");
            return (Criteria) this;
        }

        public Criteria andFrozStateNotBetween(String value1, String value2) {
            addCriterion("FROZ_STATE not between", value1, value2, "frozState");
            return (Criteria) this;
        }

        public Criteria andMarginIsNull() {
            addCriterion("MARGIN is null");
            return (Criteria) this;
        }

        public Criteria andMarginIsNotNull() {
            addCriterion("MARGIN is not null");
            return (Criteria) this;
        }

        public Criteria andMarginEqualTo(String value) {
            addCriterion("MARGIN =", value, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginNotEqualTo(String value) {
            addCriterion("MARGIN <>", value, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginGreaterThan(String value) {
            addCriterion("MARGIN >", value, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginGreaterThanOrEqualTo(String value) {
            addCriterion("MARGIN >=", value, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginLessThan(String value) {
            addCriterion("MARGIN <", value, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginLessThanOrEqualTo(String value) {
            addCriterion("MARGIN <=", value, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginLike(String value) {
            addCriterion("MARGIN like", value, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginNotLike(String value) {
            addCriterion("MARGIN not like", value, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginIn(List<String> values) {
            addCriterion("MARGIN in", values, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginNotIn(List<String> values) {
            addCriterion("MARGIN not in", values, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginBetween(String value1, String value2) {
            addCriterion("MARGIN between", value1, value2, "margin");
            return (Criteria) this;
        }

        public Criteria andMarginNotBetween(String value1, String value2) {
            addCriterion("MARGIN not between", value1, value2, "margin");
            return (Criteria) this;
        }

        public Criteria andContractStrDateIsNull() {
            addCriterion("CONTRACT_STR_DATE is null");
            return (Criteria) this;
        }

        public Criteria andContractStrDateIsNotNull() {
            addCriterion("CONTRACT_STR_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andContractStrDateEqualTo(String value) {
            addCriterion("CONTRACT_STR_DATE =", value, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateNotEqualTo(String value) {
            addCriterion("CONTRACT_STR_DATE <>", value, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateGreaterThan(String value) {
            addCriterion("CONTRACT_STR_DATE >", value, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateGreaterThanOrEqualTo(String value) {
            addCriterion("CONTRACT_STR_DATE >=", value, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateLessThan(String value) {
            addCriterion("CONTRACT_STR_DATE <", value, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateLessThanOrEqualTo(String value) {
            addCriterion("CONTRACT_STR_DATE <=", value, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateLike(String value) {
            addCriterion("CONTRACT_STR_DATE like", value, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateNotLike(String value) {
            addCriterion("CONTRACT_STR_DATE not like", value, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateIn(List<String> values) {
            addCriterion("CONTRACT_STR_DATE in", values, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateNotIn(List<String> values) {
            addCriterion("CONTRACT_STR_DATE not in", values, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateBetween(String value1, String value2) {
            addCriterion("CONTRACT_STR_DATE between", value1, value2, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractStrDateNotBetween(String value1, String value2) {
            addCriterion("CONTRACT_STR_DATE not between", value1, value2, "contractStrDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNull() {
            addCriterion("CONTRACT_END_DATE is null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNotNull() {
            addCriterion("CONTRACT_END_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateEqualTo(String value) {
            addCriterion("CONTRACT_END_DATE =", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotEqualTo(String value) {
            addCriterion("CONTRACT_END_DATE <>", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThan(String value) {
            addCriterion("CONTRACT_END_DATE >", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThanOrEqualTo(String value) {
            addCriterion("CONTRACT_END_DATE >=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThan(String value) {
            addCriterion("CONTRACT_END_DATE <", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThanOrEqualTo(String value) {
            addCriterion("CONTRACT_END_DATE <=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLike(String value) {
            addCriterion("CONTRACT_END_DATE like", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotLike(String value) {
            addCriterion("CONTRACT_END_DATE not like", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIn(List<String> values) {
            addCriterion("CONTRACT_END_DATE in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotIn(List<String> values) {
            addCriterion("CONTRACT_END_DATE not in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateBetween(String value1, String value2) {
            addCriterion("CONTRACT_END_DATE between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotBetween(String value1, String value2) {
            addCriterion("CONTRACT_END_DATE not between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andAgeStatusIsNull() {
            addCriterion("AGE_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andAgeStatusIsNotNull() {
            addCriterion("AGE_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andAgeStatusEqualTo(String value) {
            addCriterion("AGE_STATUS =", value, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusNotEqualTo(String value) {
            addCriterion("AGE_STATUS <>", value, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusGreaterThan(String value) {
            addCriterion("AGE_STATUS >", value, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusGreaterThanOrEqualTo(String value) {
            addCriterion("AGE_STATUS >=", value, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusLessThan(String value) {
            addCriterion("AGE_STATUS <", value, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusLessThanOrEqualTo(String value) {
            addCriterion("AGE_STATUS <=", value, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusLike(String value) {
            addCriterion("AGE_STATUS like", value, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusNotLike(String value) {
            addCriterion("AGE_STATUS not like", value, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusIn(List<String> values) {
            addCriterion("AGE_STATUS in", values, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusNotIn(List<String> values) {
            addCriterion("AGE_STATUS not in", values, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusBetween(String value1, String value2) {
            addCriterion("AGE_STATUS between", value1, value2, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andAgeStatusNotBetween(String value1, String value2) {
            addCriterion("AGE_STATUS not between", value1, value2, "ageStatus");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("REMARK is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("REMARK =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("REMARK <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("REMARK >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("REMARK >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("REMARK <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("REMARK <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("REMARK like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("REMARK not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("REMARK in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("REMARK not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("REMARK between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("REMARK not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andFiled1IsNull() {
            addCriterion("FILED1 is null");
            return (Criteria) this;
        }

        public Criteria andFiled1IsNotNull() {
            addCriterion("FILED1 is not null");
            return (Criteria) this;
        }

        public Criteria andFiled1EqualTo(String value) {
            addCriterion("FILED1 =", value, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1NotEqualTo(String value) {
            addCriterion("FILED1 <>", value, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1GreaterThan(String value) {
            addCriterion("FILED1 >", value, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1GreaterThanOrEqualTo(String value) {
            addCriterion("FILED1 >=", value, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1LessThan(String value) {
            addCriterion("FILED1 <", value, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1LessThanOrEqualTo(String value) {
            addCriterion("FILED1 <=", value, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1Like(String value) {
            addCriterion("FILED1 like", value, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1NotLike(String value) {
            addCriterion("FILED1 not like", value, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1In(List<String> values) {
            addCriterion("FILED1 in", values, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1NotIn(List<String> values) {
            addCriterion("FILED1 not in", values, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1Between(String value1, String value2) {
            addCriterion("FILED1 between", value1, value2, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled1NotBetween(String value1, String value2) {
            addCriterion("FILED1 not between", value1, value2, "filed1");
            return (Criteria) this;
        }

        public Criteria andFiled2IsNull() {
            addCriterion("FILED2 is null");
            return (Criteria) this;
        }

        public Criteria andFiled2IsNotNull() {
            addCriterion("FILED2 is not null");
            return (Criteria) this;
        }

        public Criteria andFiled2EqualTo(String value) {
            addCriterion("FILED2 =", value, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2NotEqualTo(String value) {
            addCriterion("FILED2 <>", value, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2GreaterThan(String value) {
            addCriterion("FILED2 >", value, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2GreaterThanOrEqualTo(String value) {
            addCriterion("FILED2 >=", value, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2LessThan(String value) {
            addCriterion("FILED2 <", value, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2LessThanOrEqualTo(String value) {
            addCriterion("FILED2 <=", value, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2Like(String value) {
            addCriterion("FILED2 like", value, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2NotLike(String value) {
            addCriterion("FILED2 not like", value, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2In(List<String> values) {
            addCriterion("FILED2 in", values, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2NotIn(List<String> values) {
            addCriterion("FILED2 not in", values, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2Between(String value1, String value2) {
            addCriterion("FILED2 between", value1, value2, "filed2");
            return (Criteria) this;
        }

        public Criteria andFiled2NotBetween(String value1, String value2) {
            addCriterion("FILED2 not between", value1, value2, "filed2");
            return (Criteria) this;
        }

        public Criteria andTechcontactIsNull() {
            addCriterion("TECHCONTACT is null");
            return (Criteria) this;
        }

        public Criteria andTechcontactIsNotNull() {
            addCriterion("TECHCONTACT is not null");
            return (Criteria) this;
        }

        public Criteria andTechcontactEqualTo(String value) {
            addCriterion("TECHCONTACT =", value, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactNotEqualTo(String value) {
            addCriterion("TECHCONTACT <>", value, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactGreaterThan(String value) {
            addCriterion("TECHCONTACT >", value, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactGreaterThanOrEqualTo(String value) {
            addCriterion("TECHCONTACT >=", value, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactLessThan(String value) {
            addCriterion("TECHCONTACT <", value, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactLessThanOrEqualTo(String value) {
            addCriterion("TECHCONTACT <=", value, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactLike(String value) {
            addCriterion("TECHCONTACT like", value, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactNotLike(String value) {
            addCriterion("TECHCONTACT not like", value, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactIn(List<String> values) {
            addCriterion("TECHCONTACT in", values, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactNotIn(List<String> values) {
            addCriterion("TECHCONTACT not in", values, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactBetween(String value1, String value2) {
            addCriterion("TECHCONTACT between", value1, value2, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechcontactNotBetween(String value1, String value2) {
            addCriterion("TECHCONTACT not between", value1, value2, "techcontact");
            return (Criteria) this;
        }

        public Criteria andTechtelnoIsNull() {
            addCriterion("TECHTELNO is null");
            return (Criteria) this;
        }

        public Criteria andTechtelnoIsNotNull() {
            addCriterion("TECHTELNO is not null");
            return (Criteria) this;
        }

        public Criteria andTechtelnoEqualTo(String value) {
            addCriterion("TECHTELNO =", value, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoNotEqualTo(String value) {
            addCriterion("TECHTELNO <>", value, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoGreaterThan(String value) {
            addCriterion("TECHTELNO >", value, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoGreaterThanOrEqualTo(String value) {
            addCriterion("TECHTELNO >=", value, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoLessThan(String value) {
            addCriterion("TECHTELNO <", value, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoLessThanOrEqualTo(String value) {
            addCriterion("TECHTELNO <=", value, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoLike(String value) {
            addCriterion("TECHTELNO like", value, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoNotLike(String value) {
            addCriterion("TECHTELNO not like", value, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoIn(List<String> values) {
            addCriterion("TECHTELNO in", values, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoNotIn(List<String> values) {
            addCriterion("TECHTELNO not in", values, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoBetween(String value1, String value2) {
            addCriterion("TECHTELNO between", value1, value2, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechtelnoNotBetween(String value1, String value2) {
            addCriterion("TECHTELNO not between", value1, value2, "techtelno");
            return (Criteria) this;
        }

        public Criteria andTechemailIsNull() {
            addCriterion("TECHEMAIL is null");
            return (Criteria) this;
        }

        public Criteria andTechemailIsNotNull() {
            addCriterion("TECHEMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andTechemailEqualTo(String value) {
            addCriterion("TECHEMAIL =", value, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailNotEqualTo(String value) {
            addCriterion("TECHEMAIL <>", value, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailGreaterThan(String value) {
            addCriterion("TECHEMAIL >", value, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailGreaterThanOrEqualTo(String value) {
            addCriterion("TECHEMAIL >=", value, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailLessThan(String value) {
            addCriterion("TECHEMAIL <", value, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailLessThanOrEqualTo(String value) {
            addCriterion("TECHEMAIL <=", value, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailLike(String value) {
            addCriterion("TECHEMAIL like", value, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailNotLike(String value) {
            addCriterion("TECHEMAIL not like", value, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailIn(List<String> values) {
            addCriterion("TECHEMAIL in", values, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailNotIn(List<String> values) {
            addCriterion("TECHEMAIL not in", values, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailBetween(String value1, String value2) {
            addCriterion("TECHEMAIL between", value1, value2, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechemailNotBetween(String value1, String value2) {
            addCriterion("TECHEMAIL not between", value1, value2, "techemail");
            return (Criteria) this;
        }

        public Criteria andTechmobnoIsNull() {
            addCriterion("TECHMOBNO is null");
            return (Criteria) this;
        }

        public Criteria andTechmobnoIsNotNull() {
            addCriterion("TECHMOBNO is not null");
            return (Criteria) this;
        }

        public Criteria andTechmobnoEqualTo(String value) {
            addCriterion("TECHMOBNO =", value, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoNotEqualTo(String value) {
            addCriterion("TECHMOBNO <>", value, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoGreaterThan(String value) {
            addCriterion("TECHMOBNO >", value, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoGreaterThanOrEqualTo(String value) {
            addCriterion("TECHMOBNO >=", value, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoLessThan(String value) {
            addCriterion("TECHMOBNO <", value, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoLessThanOrEqualTo(String value) {
            addCriterion("TECHMOBNO <=", value, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoLike(String value) {
            addCriterion("TECHMOBNO like", value, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoNotLike(String value) {
            addCriterion("TECHMOBNO not like", value, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoIn(List<String> values) {
            addCriterion("TECHMOBNO in", values, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoNotIn(List<String> values) {
            addCriterion("TECHMOBNO not in", values, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoBetween(String value1, String value2) {
            addCriterion("TECHMOBNO between", value1, value2, "techmobno");
            return (Criteria) this;
        }

        public Criteria andTechmobnoNotBetween(String value1, String value2) {
            addCriterion("TECHMOBNO not between", value1, value2, "techmobno");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("CITY is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("CITY is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("CITY =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("CITY <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("CITY >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("CITY >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("CITY <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("CITY <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("CITY like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("CITY not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("CITY in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("CITY not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("CITY between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("CITY not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("PROVINCE is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("PROVINCE is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("PROVINCE =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("PROVINCE <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("PROVINCE >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("PROVINCE >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("PROVINCE <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("PROVINCE <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("PROVINCE like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("PROVINCE not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("PROVINCE in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("PROVINCE not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("PROVINCE between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("PROVINCE not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andBizcontactIsNull() {
            addCriterion("BIZCONTACT is null");
            return (Criteria) this;
        }

        public Criteria andBizcontactIsNotNull() {
            addCriterion("BIZCONTACT is not null");
            return (Criteria) this;
        }

        public Criteria andBizcontactEqualTo(String value) {
            addCriterion("BIZCONTACT =", value, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactNotEqualTo(String value) {
            addCriterion("BIZCONTACT <>", value, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactGreaterThan(String value) {
            addCriterion("BIZCONTACT >", value, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactGreaterThanOrEqualTo(String value) {
            addCriterion("BIZCONTACT >=", value, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactLessThan(String value) {
            addCriterion("BIZCONTACT <", value, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactLessThanOrEqualTo(String value) {
            addCriterion("BIZCONTACT <=", value, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactLike(String value) {
            addCriterion("BIZCONTACT like", value, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactNotLike(String value) {
            addCriterion("BIZCONTACT not like", value, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactIn(List<String> values) {
            addCriterion("BIZCONTACT in", values, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactNotIn(List<String> values) {
            addCriterion("BIZCONTACT not in", values, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactBetween(String value1, String value2) {
            addCriterion("BIZCONTACT between", value1, value2, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizcontactNotBetween(String value1, String value2) {
            addCriterion("BIZCONTACT not between", value1, value2, "bizcontact");
            return (Criteria) this;
        }

        public Criteria andBizmobnoIsNull() {
            addCriterion("BIZMOBNO is null");
            return (Criteria) this;
        }

        public Criteria andBizmobnoIsNotNull() {
            addCriterion("BIZMOBNO is not null");
            return (Criteria) this;
        }

        public Criteria andBizmobnoEqualTo(String value) {
            addCriterion("BIZMOBNO =", value, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoNotEqualTo(String value) {
            addCriterion("BIZMOBNO <>", value, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoGreaterThan(String value) {
            addCriterion("BIZMOBNO >", value, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoGreaterThanOrEqualTo(String value) {
            addCriterion("BIZMOBNO >=", value, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoLessThan(String value) {
            addCriterion("BIZMOBNO <", value, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoLessThanOrEqualTo(String value) {
            addCriterion("BIZMOBNO <=", value, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoLike(String value) {
            addCriterion("BIZMOBNO like", value, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoNotLike(String value) {
            addCriterion("BIZMOBNO not like", value, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoIn(List<String> values) {
            addCriterion("BIZMOBNO in", values, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoNotIn(List<String> values) {
            addCriterion("BIZMOBNO not in", values, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoBetween(String value1, String value2) {
            addCriterion("BIZMOBNO between", value1, value2, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andBizmobnoNotBetween(String value1, String value2) {
            addCriterion("BIZMOBNO not between", value1, value2, "bizmobno");
            return (Criteria) this;
        }

        public Criteria andServcontactIsNull() {
            addCriterion("SERVCONTACT is null");
            return (Criteria) this;
        }

        public Criteria andServcontactIsNotNull() {
            addCriterion("SERVCONTACT is not null");
            return (Criteria) this;
        }

        public Criteria andServcontactEqualTo(String value) {
            addCriterion("SERVCONTACT =", value, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactNotEqualTo(String value) {
            addCriterion("SERVCONTACT <>", value, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactGreaterThan(String value) {
            addCriterion("SERVCONTACT >", value, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactGreaterThanOrEqualTo(String value) {
            addCriterion("SERVCONTACT >=", value, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactLessThan(String value) {
            addCriterion("SERVCONTACT <", value, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactLessThanOrEqualTo(String value) {
            addCriterion("SERVCONTACT <=", value, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactLike(String value) {
            addCriterion("SERVCONTACT like", value, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactNotLike(String value) {
            addCriterion("SERVCONTACT not like", value, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactIn(List<String> values) {
            addCriterion("SERVCONTACT in", values, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactNotIn(List<String> values) {
            addCriterion("SERVCONTACT not in", values, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactBetween(String value1, String value2) {
            addCriterion("SERVCONTACT between", value1, value2, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServcontactNotBetween(String value1, String value2) {
            addCriterion("SERVCONTACT not between", value1, value2, "servcontact");
            return (Criteria) this;
        }

        public Criteria andServmobnoIsNull() {
            addCriterion("SERVMOBNO is null");
            return (Criteria) this;
        }

        public Criteria andServmobnoIsNotNull() {
            addCriterion("SERVMOBNO is not null");
            return (Criteria) this;
        }

        public Criteria andServmobnoEqualTo(String value) {
            addCriterion("SERVMOBNO =", value, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoNotEqualTo(String value) {
            addCriterion("SERVMOBNO <>", value, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoGreaterThan(String value) {
            addCriterion("SERVMOBNO >", value, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoGreaterThanOrEqualTo(String value) {
            addCriterion("SERVMOBNO >=", value, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoLessThan(String value) {
            addCriterion("SERVMOBNO <", value, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoLessThanOrEqualTo(String value) {
            addCriterion("SERVMOBNO <=", value, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoLike(String value) {
            addCriterion("SERVMOBNO like", value, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoNotLike(String value) {
            addCriterion("SERVMOBNO not like", value, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoIn(List<String> values) {
            addCriterion("SERVMOBNO in", values, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoNotIn(List<String> values) {
            addCriterion("SERVMOBNO not in", values, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoBetween(String value1, String value2) {
            addCriterion("SERVMOBNO between", value1, value2, "servmobno");
            return (Criteria) this;
        }

        public Criteria andServmobnoNotBetween(String value1, String value2) {
            addCriterion("SERVMOBNO not between", value1, value2, "servmobno");
            return (Criteria) this;
        }

        public Criteria andOemStateIsNull() {
            addCriterion("OEM_STATE is null");
            return (Criteria) this;
        }

        public Criteria andOemStateIsNotNull() {
            addCriterion("OEM_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andOemStateEqualTo(String value) {
            addCriterion("OEM_STATE =", value, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateNotEqualTo(String value) {
            addCriterion("OEM_STATE <>", value, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateGreaterThan(String value) {
            addCriterion("OEM_STATE >", value, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateGreaterThanOrEqualTo(String value) {
            addCriterion("OEM_STATE >=", value, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateLessThan(String value) {
            addCriterion("OEM_STATE <", value, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateLessThanOrEqualTo(String value) {
            addCriterion("OEM_STATE <=", value, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateLike(String value) {
            addCriterion("OEM_STATE like", value, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateNotLike(String value) {
            addCriterion("OEM_STATE not like", value, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateIn(List<String> values) {
            addCriterion("OEM_STATE in", values, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateNotIn(List<String> values) {
            addCriterion("OEM_STATE not in", values, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateBetween(String value1, String value2) {
            addCriterion("OEM_STATE between", value1, value2, "oemState");
            return (Criteria) this;
        }

        public Criteria andOemStateNotBetween(String value1, String value2) {
            addCriterion("OEM_STATE not between", value1, value2, "oemState");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodIsNull() {
            addCriterion("RATE_LIVELIHOOD is null");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodIsNotNull() {
            addCriterion("RATE_LIVELIHOOD is not null");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodEqualTo(String value) {
            addCriterion("RATE_LIVELIHOOD =", value, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodNotEqualTo(String value) {
            addCriterion("RATE_LIVELIHOOD <>", value, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodGreaterThan(String value) {
            addCriterion("RATE_LIVELIHOOD >", value, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_LIVELIHOOD >=", value, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodLessThan(String value) {
            addCriterion("RATE_LIVELIHOOD <", value, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodLessThanOrEqualTo(String value) {
            addCriterion("RATE_LIVELIHOOD <=", value, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodLike(String value) {
            addCriterion("RATE_LIVELIHOOD like", value, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodNotLike(String value) {
            addCriterion("RATE_LIVELIHOOD not like", value, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodIn(List<String> values) {
            addCriterion("RATE_LIVELIHOOD in", values, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodNotIn(List<String> values) {
            addCriterion("RATE_LIVELIHOOD not in", values, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodBetween(String value1, String value2) {
            addCriterion("RATE_LIVELIHOOD between", value1, value2, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateLivelihoodNotBetween(String value1, String value2) {
            addCriterion("RATE_LIVELIHOOD not between", value1, value2, "rateLivelihood");
            return (Criteria) this;
        }

        public Criteria andRateGeneralIsNull() {
            addCriterion("RATE_GENERAL is null");
            return (Criteria) this;
        }

        public Criteria andRateGeneralIsNotNull() {
            addCriterion("RATE_GENERAL is not null");
            return (Criteria) this;
        }

        public Criteria andRateGeneralEqualTo(String value) {
            addCriterion("RATE_GENERAL =", value, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralNotEqualTo(String value) {
            addCriterion("RATE_GENERAL <>", value, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralGreaterThan(String value) {
            addCriterion("RATE_GENERAL >", value, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_GENERAL >=", value, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralLessThan(String value) {
            addCriterion("RATE_GENERAL <", value, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralLessThanOrEqualTo(String value) {
            addCriterion("RATE_GENERAL <=", value, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralLike(String value) {
            addCriterion("RATE_GENERAL like", value, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralNotLike(String value) {
            addCriterion("RATE_GENERAL not like", value, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralIn(List<String> values) {
            addCriterion("RATE_GENERAL in", values, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralNotIn(List<String> values) {
            addCriterion("RATE_GENERAL not in", values, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralBetween(String value1, String value2) {
            addCriterion("RATE_GENERAL between", value1, value2, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralNotBetween(String value1, String value2) {
            addCriterion("RATE_GENERAL not between", value1, value2, "rateGeneral");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopIsNull() {
            addCriterion("RATE_GENERAL_TOP is null");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopIsNotNull() {
            addCriterion("RATE_GENERAL_TOP is not null");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopEqualTo(String value) {
            addCriterion("RATE_GENERAL_TOP =", value, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopNotEqualTo(String value) {
            addCriterion("RATE_GENERAL_TOP <>", value, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopGreaterThan(String value) {
            addCriterion("RATE_GENERAL_TOP >", value, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_GENERAL_TOP >=", value, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopLessThan(String value) {
            addCriterion("RATE_GENERAL_TOP <", value, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopLessThanOrEqualTo(String value) {
            addCriterion("RATE_GENERAL_TOP <=", value, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopLike(String value) {
            addCriterion("RATE_GENERAL_TOP like", value, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopNotLike(String value) {
            addCriterion("RATE_GENERAL_TOP not like", value, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopIn(List<String> values) {
            addCriterion("RATE_GENERAL_TOP in", values, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopNotIn(List<String> values) {
            addCriterion("RATE_GENERAL_TOP not in", values, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopBetween(String value1, String value2) {
            addCriterion("RATE_GENERAL_TOP between", value1, value2, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralTopNotBetween(String value1, String value2) {
            addCriterion("RATE_GENERAL_TOP not between", value1, value2, "rateGeneralTop");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunIsNull() {
            addCriterion("RATE_GENERAL_MAXIMUN is null");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunIsNotNull() {
            addCriterion("RATE_GENERAL_MAXIMUN is not null");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunEqualTo(String value) {
            addCriterion("RATE_GENERAL_MAXIMUN =", value, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunNotEqualTo(String value) {
            addCriterion("RATE_GENERAL_MAXIMUN <>", value, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunGreaterThan(String value) {
            addCriterion("RATE_GENERAL_MAXIMUN >", value, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_GENERAL_MAXIMUN >=", value, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunLessThan(String value) {
            addCriterion("RATE_GENERAL_MAXIMUN <", value, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunLessThanOrEqualTo(String value) {
            addCriterion("RATE_GENERAL_MAXIMUN <=", value, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunLike(String value) {
            addCriterion("RATE_GENERAL_MAXIMUN like", value, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunNotLike(String value) {
            addCriterion("RATE_GENERAL_MAXIMUN not like", value, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunIn(List<String> values) {
            addCriterion("RATE_GENERAL_MAXIMUN in", values, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunNotIn(List<String> values) {
            addCriterion("RATE_GENERAL_MAXIMUN not in", values, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunBetween(String value1, String value2) {
            addCriterion("RATE_GENERAL_MAXIMUN between", value1, value2, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateGeneralMaximunNotBetween(String value1, String value2) {
            addCriterion("RATE_GENERAL_MAXIMUN not between", value1, value2, "rateGeneralMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainIsNull() {
            addCriterion("RATE_ENTERTAIN is null");
            return (Criteria) this;
        }

        public Criteria andRateEntertainIsNotNull() {
            addCriterion("RATE_ENTERTAIN is not null");
            return (Criteria) this;
        }

        public Criteria andRateEntertainEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN =", value, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainNotEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN <>", value, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainGreaterThan(String value) {
            addCriterion("RATE_ENTERTAIN >", value, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN >=", value, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainLessThan(String value) {
            addCriterion("RATE_ENTERTAIN <", value, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainLessThanOrEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN <=", value, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainLike(String value) {
            addCriterion("RATE_ENTERTAIN like", value, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainNotLike(String value) {
            addCriterion("RATE_ENTERTAIN not like", value, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainIn(List<String> values) {
            addCriterion("RATE_ENTERTAIN in", values, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainNotIn(List<String> values) {
            addCriterion("RATE_ENTERTAIN not in", values, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainBetween(String value1, String value2) {
            addCriterion("RATE_ENTERTAIN between", value1, value2, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainNotBetween(String value1, String value2) {
            addCriterion("RATE_ENTERTAIN not between", value1, value2, "rateEntertain");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopIsNull() {
            addCriterion("RATE_ENTERTAIN_TOP is null");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopIsNotNull() {
            addCriterion("RATE_ENTERTAIN_TOP is not null");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN_TOP =", value, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopNotEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN_TOP <>", value, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopGreaterThan(String value) {
            addCriterion("RATE_ENTERTAIN_TOP >", value, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN_TOP >=", value, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopLessThan(String value) {
            addCriterion("RATE_ENTERTAIN_TOP <", value, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopLessThanOrEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN_TOP <=", value, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopLike(String value) {
            addCriterion("RATE_ENTERTAIN_TOP like", value, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopNotLike(String value) {
            addCriterion("RATE_ENTERTAIN_TOP not like", value, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopIn(List<String> values) {
            addCriterion("RATE_ENTERTAIN_TOP in", values, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopNotIn(List<String> values) {
            addCriterion("RATE_ENTERTAIN_TOP not in", values, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopBetween(String value1, String value2) {
            addCriterion("RATE_ENTERTAIN_TOP between", value1, value2, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainTopNotBetween(String value1, String value2) {
            addCriterion("RATE_ENTERTAIN_TOP not between", value1, value2, "rateEntertainTop");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunIsNull() {
            addCriterion("RATE_ENTERTAIN_MAXIMUN is null");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunIsNotNull() {
            addCriterion("RATE_ENTERTAIN_MAXIMUN is not null");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN =", value, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunNotEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN <>", value, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunGreaterThan(String value) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN >", value, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN >=", value, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunLessThan(String value) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN <", value, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunLessThanOrEqualTo(String value) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN <=", value, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunLike(String value) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN like", value, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunNotLike(String value) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN not like", value, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunIn(List<String> values) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN in", values, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunNotIn(List<String> values) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN not in", values, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunBetween(String value1, String value2) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN between", value1, value2, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateEntertainMaximunNotBetween(String value1, String value2) {
            addCriterion("RATE_ENTERTAIN_MAXIMUN not between", value1, value2, "rateEntertainMaximun");
            return (Criteria) this;
        }

        public Criteria andRateWeixinIsNull() {
            addCriterion("RATE_WEIXIN is null");
            return (Criteria) this;
        }

        public Criteria andRateWeixinIsNotNull() {
            addCriterion("RATE_WEIXIN is not null");
            return (Criteria) this;
        }

        public Criteria andRateWeixinEqualTo(String value) {
            addCriterion("RATE_WEIXIN =", value, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinNotEqualTo(String value) {
            addCriterion("RATE_WEIXIN <>", value, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinGreaterThan(String value) {
            addCriterion("RATE_WEIXIN >", value, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_WEIXIN >=", value, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinLessThan(String value) {
            addCriterion("RATE_WEIXIN <", value, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinLessThanOrEqualTo(String value) {
            addCriterion("RATE_WEIXIN <=", value, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinLike(String value) {
            addCriterion("RATE_WEIXIN like", value, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinNotLike(String value) {
            addCriterion("RATE_WEIXIN not like", value, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinIn(List<String> values) {
            addCriterion("RATE_WEIXIN in", values, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinNotIn(List<String> values) {
            addCriterion("RATE_WEIXIN not in", values, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinBetween(String value1, String value2) {
            addCriterion("RATE_WEIXIN between", value1, value2, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateWeixinNotBetween(String value1, String value2) {
            addCriterion("RATE_WEIXIN not between", value1, value2, "rateWeixin");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoIsNull() {
            addCriterion("RATE_ZHIFUBAO is null");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoIsNotNull() {
            addCriterion("RATE_ZHIFUBAO is not null");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoEqualTo(String value) {
            addCriterion("RATE_ZHIFUBAO =", value, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoNotEqualTo(String value) {
            addCriterion("RATE_ZHIFUBAO <>", value, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoGreaterThan(String value) {
            addCriterion("RATE_ZHIFUBAO >", value, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_ZHIFUBAO >=", value, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoLessThan(String value) {
            addCriterion("RATE_ZHIFUBAO <", value, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoLessThanOrEqualTo(String value) {
            addCriterion("RATE_ZHIFUBAO <=", value, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoLike(String value) {
            addCriterion("RATE_ZHIFUBAO like", value, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoNotLike(String value) {
            addCriterion("RATE_ZHIFUBAO not like", value, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoIn(List<String> values) {
            addCriterion("RATE_ZHIFUBAO in", values, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoNotIn(List<String> values) {
            addCriterion("RATE_ZHIFUBAO not in", values, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoBetween(String value1, String value2) {
            addCriterion("RATE_ZHIFUBAO between", value1, value2, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateZhifubaoNotBetween(String value1, String value2) {
            addCriterion("RATE_ZHIFUBAO not between", value1, value2, "rateZhifubao");
            return (Criteria) this;
        }

        public Criteria andRateQuickIsNull() {
            addCriterion("RATE_QUICK is null");
            return (Criteria) this;
        }

        public Criteria andRateQuickIsNotNull() {
            addCriterion("RATE_QUICK is not null");
            return (Criteria) this;
        }

        public Criteria andRateQuickEqualTo(String value) {
            addCriterion("RATE_QUICK =", value, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickNotEqualTo(String value) {
            addCriterion("RATE_QUICK <>", value, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickGreaterThan(String value) {
            addCriterion("RATE_QUICK >", value, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickGreaterThanOrEqualTo(String value) {
            addCriterion("RATE_QUICK >=", value, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickLessThan(String value) {
            addCriterion("RATE_QUICK <", value, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickLessThanOrEqualTo(String value) {
            addCriterion("RATE_QUICK <=", value, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickLike(String value) {
            addCriterion("RATE_QUICK like", value, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickNotLike(String value) {
            addCriterion("RATE_QUICK not like", value, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickIn(List<String> values) {
            addCriterion("RATE_QUICK in", values, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickNotIn(List<String> values) {
            addCriterion("RATE_QUICK not in", values, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickBetween(String value1, String value2) {
            addCriterion("RATE_QUICK between", value1, value2, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andRateQuickNotBetween(String value1, String value2) {
            addCriterion("RATE_QUICK not between", value1, value2, "rateQuick");
            return (Criteria) this;
        }

        public Criteria andSlttypIsNull() {
            addCriterion("SLTTYP is null");
            return (Criteria) this;
        }

        public Criteria andSlttypIsNotNull() {
            addCriterion("SLTTYP is not null");
            return (Criteria) this;
        }

        public Criteria andSlttypEqualTo(String value) {
            addCriterion("SLTTYP =", value, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypNotEqualTo(String value) {
            addCriterion("SLTTYP <>", value, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypGreaterThan(String value) {
            addCriterion("SLTTYP >", value, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypGreaterThanOrEqualTo(String value) {
            addCriterion("SLTTYP >=", value, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypLessThan(String value) {
            addCriterion("SLTTYP <", value, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypLessThanOrEqualTo(String value) {
            addCriterion("SLTTYP <=", value, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypLike(String value) {
            addCriterion("SLTTYP like", value, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypNotLike(String value) {
            addCriterion("SLTTYP not like", value, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypIn(List<String> values) {
            addCriterion("SLTTYP in", values, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypNotIn(List<String> values) {
            addCriterion("SLTTYP not in", values, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypBetween(String value1, String value2) {
            addCriterion("SLTTYP between", value1, value2, "slttyp");
            return (Criteria) this;
        }

        public Criteria andSlttypNotBetween(String value1, String value2) {
            addCriterion("SLTTYP not between", value1, value2, "slttyp");
            return (Criteria) this;
        }

        public Criteria andEfftimIsNull() {
            addCriterion("EFFTIM is null");
            return (Criteria) this;
        }

        public Criteria andEfftimIsNotNull() {
            addCriterion("EFFTIM is not null");
            return (Criteria) this;
        }

        public Criteria andEfftimEqualTo(String value) {
            addCriterion("EFFTIM =", value, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimNotEqualTo(String value) {
            addCriterion("EFFTIM <>", value, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimGreaterThan(String value) {
            addCriterion("EFFTIM >", value, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimGreaterThanOrEqualTo(String value) {
            addCriterion("EFFTIM >=", value, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimLessThan(String value) {
            addCriterion("EFFTIM <", value, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimLessThanOrEqualTo(String value) {
            addCriterion("EFFTIM <=", value, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimLike(String value) {
            addCriterion("EFFTIM like", value, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimNotLike(String value) {
            addCriterion("EFFTIM not like", value, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimIn(List<String> values) {
            addCriterion("EFFTIM in", values, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimNotIn(List<String> values) {
            addCriterion("EFFTIM not in", values, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimBetween(String value1, String value2) {
            addCriterion("EFFTIM between", value1, value2, "efftim");
            return (Criteria) this;
        }

        public Criteria andEfftimNotBetween(String value1, String value2) {
            addCriterion("EFFTIM not between", value1, value2, "efftim");
            return (Criteria) this;
        }

        public Criteria andTiflgIsNull() {
            addCriterion("TIFLG is null");
            return (Criteria) this;
        }

        public Criteria andTiflgIsNotNull() {
            addCriterion("TIFLG is not null");
            return (Criteria) this;
        }

        public Criteria andTiflgEqualTo(String value) {
            addCriterion("TIFLG =", value, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgNotEqualTo(String value) {
            addCriterion("TIFLG <>", value, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgGreaterThan(String value) {
            addCriterion("TIFLG >", value, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgGreaterThanOrEqualTo(String value) {
            addCriterion("TIFLG >=", value, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgLessThan(String value) {
            addCriterion("TIFLG <", value, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgLessThanOrEqualTo(String value) {
            addCriterion("TIFLG <=", value, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgLike(String value) {
            addCriterion("TIFLG like", value, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgNotLike(String value) {
            addCriterion("TIFLG not like", value, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgIn(List<String> values) {
            addCriterion("TIFLG in", values, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgNotIn(List<String> values) {
            addCriterion("TIFLG not in", values, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgBetween(String value1, String value2) {
            addCriterion("TIFLG between", value1, value2, "tiflg");
            return (Criteria) this;
        }

        public Criteria andTiflgNotBetween(String value1, String value2) {
            addCriterion("TIFLG not between", value1, value2, "tiflg");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoIsNull() {
            addCriterion("BANKPAYACNO is null");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoIsNotNull() {
            addCriterion("BANKPAYACNO is not null");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoEqualTo(String value) {
            addCriterion("BANKPAYACNO =", value, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoNotEqualTo(String value) {
            addCriterion("BANKPAYACNO <>", value, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoGreaterThan(String value) {
            addCriterion("BANKPAYACNO >", value, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoGreaterThanOrEqualTo(String value) {
            addCriterion("BANKPAYACNO >=", value, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoLessThan(String value) {
            addCriterion("BANKPAYACNO <", value, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoLessThanOrEqualTo(String value) {
            addCriterion("BANKPAYACNO <=", value, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoLike(String value) {
            addCriterion("BANKPAYACNO like", value, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoNotLike(String value) {
            addCriterion("BANKPAYACNO not like", value, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoIn(List<String> values) {
            addCriterion("BANKPAYACNO in", values, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoNotIn(List<String> values) {
            addCriterion("BANKPAYACNO not in", values, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoBetween(String value1, String value2) {
            addCriterion("BANKPAYACNO between", value1, value2, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayacnoNotBetween(String value1, String value2) {
            addCriterion("BANKPAYACNO not between", value1, value2, "bankpayacno");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmIsNull() {
            addCriterion("BANKPAYUSERNM is null");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmIsNotNull() {
            addCriterion("BANKPAYUSERNM is not null");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmEqualTo(String value) {
            addCriterion("BANKPAYUSERNM =", value, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmNotEqualTo(String value) {
            addCriterion("BANKPAYUSERNM <>", value, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmGreaterThan(String value) {
            addCriterion("BANKPAYUSERNM >", value, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmGreaterThanOrEqualTo(String value) {
            addCriterion("BANKPAYUSERNM >=", value, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmLessThan(String value) {
            addCriterion("BANKPAYUSERNM <", value, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmLessThanOrEqualTo(String value) {
            addCriterion("BANKPAYUSERNM <=", value, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmLike(String value) {
            addCriterion("BANKPAYUSERNM like", value, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmNotLike(String value) {
            addCriterion("BANKPAYUSERNM not like", value, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmIn(List<String> values) {
            addCriterion("BANKPAYUSERNM in", values, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmNotIn(List<String> values) {
            addCriterion("BANKPAYUSERNM not in", values, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmBetween(String value1, String value2) {
            addCriterion("BANKPAYUSERNM between", value1, value2, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankpayusernmNotBetween(String value1, String value2) {
            addCriterion("BANKPAYUSERNM not between", value1, value2, "bankpayusernm");
            return (Criteria) this;
        }

        public Criteria andBankcodeIsNull() {
            addCriterion("BANKCODE is null");
            return (Criteria) this;
        }

        public Criteria andBankcodeIsNotNull() {
            addCriterion("BANKCODE is not null");
            return (Criteria) this;
        }

        public Criteria andBankcodeEqualTo(String value) {
            addCriterion("BANKCODE =", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotEqualTo(String value) {
            addCriterion("BANKCODE <>", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeGreaterThan(String value) {
            addCriterion("BANKCODE >", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeGreaterThanOrEqualTo(String value) {
            addCriterion("BANKCODE >=", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeLessThan(String value) {
            addCriterion("BANKCODE <", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeLessThanOrEqualTo(String value) {
            addCriterion("BANKCODE <=", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeLike(String value) {
            addCriterion("BANKCODE like", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotLike(String value) {
            addCriterion("BANKCODE not like", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeIn(List<String> values) {
            addCriterion("BANKCODE in", values, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotIn(List<String> values) {
            addCriterion("BANKCODE not in", values, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeBetween(String value1, String value2) {
            addCriterion("BANKCODE between", value1, value2, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotBetween(String value1, String value2) {
            addCriterion("BANKCODE not between", value1, value2, "bankcode");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(String value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(String value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(String value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(String value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLike(String value) {
            addCriterion("CREATE_DATE like", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotLike(String value) {
            addCriterion("CREATE_DATE not like", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<String> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<String> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(String value1, String value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(String value1, String value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNull() {
            addCriterion("CREATE_USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNotNull() {
            addCriterion("CREATE_USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdEqualTo(String value) {
            addCriterion("CREATE_USER_ID =", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotEqualTo(String value) {
            addCriterion("CREATE_USER_ID <>", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThan(String value) {
            addCriterion("CREATE_USER_ID >", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER_ID >=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThan(String value) {
            addCriterion("CREATE_USER_ID <", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER_ID <=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLike(String value) {
            addCriterion("CREATE_USER_ID like", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotLike(String value) {
            addCriterion("CREATE_USER_ID not like", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIn(List<String> values) {
            addCriterion("CREATE_USER_ID in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotIn(List<String> values) {
            addCriterion("CREATE_USER_ID not in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdBetween(String value1, String value2) {
            addCriterion("CREATE_USER_ID between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER_ID not between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andEditDateIsNull() {
            addCriterion("EDIT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andEditDateIsNotNull() {
            addCriterion("EDIT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andEditDateEqualTo(String value) {
            addCriterion("EDIT_DATE =", value, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateNotEqualTo(String value) {
            addCriterion("EDIT_DATE <>", value, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateGreaterThan(String value) {
            addCriterion("EDIT_DATE >", value, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateGreaterThanOrEqualTo(String value) {
            addCriterion("EDIT_DATE >=", value, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateLessThan(String value) {
            addCriterion("EDIT_DATE <", value, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateLessThanOrEqualTo(String value) {
            addCriterion("EDIT_DATE <=", value, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateLike(String value) {
            addCriterion("EDIT_DATE like", value, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateNotLike(String value) {
            addCriterion("EDIT_DATE not like", value, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateIn(List<String> values) {
            addCriterion("EDIT_DATE in", values, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateNotIn(List<String> values) {
            addCriterion("EDIT_DATE not in", values, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateBetween(String value1, String value2) {
            addCriterion("EDIT_DATE between", value1, value2, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditDateNotBetween(String value1, String value2) {
            addCriterion("EDIT_DATE not between", value1, value2, "editDate");
            return (Criteria) this;
        }

        public Criteria andEditUserIdIsNull() {
            addCriterion("EDIT_USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andEditUserIdIsNotNull() {
            addCriterion("EDIT_USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andEditUserIdEqualTo(String value) {
            addCriterion("EDIT_USER_ID =", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdNotEqualTo(String value) {
            addCriterion("EDIT_USER_ID <>", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdGreaterThan(String value) {
            addCriterion("EDIT_USER_ID >", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("EDIT_USER_ID >=", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdLessThan(String value) {
            addCriterion("EDIT_USER_ID <", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdLessThanOrEqualTo(String value) {
            addCriterion("EDIT_USER_ID <=", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdLike(String value) {
            addCriterion("EDIT_USER_ID like", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdNotLike(String value) {
            addCriterion("EDIT_USER_ID not like", value, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdIn(List<String> values) {
            addCriterion("EDIT_USER_ID in", values, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdNotIn(List<String> values) {
            addCriterion("EDIT_USER_ID not in", values, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdBetween(String value1, String value2) {
            addCriterion("EDIT_USER_ID between", value1, value2, "editUserId");
            return (Criteria) this;
        }

        public Criteria andEditUserIdNotBetween(String value1, String value2) {
            addCriterion("EDIT_USER_ID not between", value1, value2, "editUserId");
            return (Criteria) this;
        }

        public Criteria andAgentCodeIsNull() {
            addCriterion("AGENT_CODE is null");
            return (Criteria) this;
        }

        public Criteria andAgentCodeIsNotNull() {
            addCriterion("AGENT_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andAgentCodeEqualTo(String value) {
            addCriterion("AGENT_CODE =", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeNotEqualTo(String value) {
            addCriterion("AGENT_CODE <>", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeGreaterThan(String value) {
            addCriterion("AGENT_CODE >", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_CODE >=", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeLessThan(String value) {
            addCriterion("AGENT_CODE <", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeLessThanOrEqualTo(String value) {
            addCriterion("AGENT_CODE <=", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeLike(String value) {
            addCriterion("AGENT_CODE like", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeNotLike(String value) {
            addCriterion("AGENT_CODE not like", value, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeIn(List<String> values) {
            addCriterion("AGENT_CODE in", values, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeNotIn(List<String> values) {
            addCriterion("AGENT_CODE not in", values, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeBetween(String value1, String value2) {
            addCriterion("AGENT_CODE between", value1, value2, "agentCode");
            return (Criteria) this;
        }

        public Criteria andAgentCodeNotBetween(String value1, String value2) {
            addCriterion("AGENT_CODE not between", value1, value2, "agentCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeIsNull() {
            addCriterion("FATHER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andFatherCodeIsNotNull() {
            addCriterion("FATHER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andFatherCodeEqualTo(String value) {
            addCriterion("FATHER_CODE =", value, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeNotEqualTo(String value) {
            addCriterion("FATHER_CODE <>", value, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeGreaterThan(String value) {
            addCriterion("FATHER_CODE >", value, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeGreaterThanOrEqualTo(String value) {
            addCriterion("FATHER_CODE >=", value, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeLessThan(String value) {
            addCriterion("FATHER_CODE <", value, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeLessThanOrEqualTo(String value) {
            addCriterion("FATHER_CODE <=", value, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeLike(String value) {
            addCriterion("FATHER_CODE like", value, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeNotLike(String value) {
            addCriterion("FATHER_CODE not like", value, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeIn(List<String> values) {
            addCriterion("FATHER_CODE in", values, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeNotIn(List<String> values) {
            addCriterion("FATHER_CODE not in", values, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeBetween(String value1, String value2) {
            addCriterion("FATHER_CODE between", value1, value2, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andFatherCodeNotBetween(String value1, String value2) {
            addCriterion("FATHER_CODE not between", value1, value2, "fatherCode");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidIsNull() {
            addCriterion("AUDIT_AGENTID is null");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidIsNotNull() {
            addCriterion("AUDIT_AGENTID is not null");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidEqualTo(String value) {
            addCriterion("AUDIT_AGENTID =", value, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidNotEqualTo(String value) {
            addCriterion("AUDIT_AGENTID <>", value, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidGreaterThan(String value) {
            addCriterion("AUDIT_AGENTID >", value, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidGreaterThanOrEqualTo(String value) {
            addCriterion("AUDIT_AGENTID >=", value, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidLessThan(String value) {
            addCriterion("AUDIT_AGENTID <", value, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidLessThanOrEqualTo(String value) {
            addCriterion("AUDIT_AGENTID <=", value, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidLike(String value) {
            addCriterion("AUDIT_AGENTID like", value, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidNotLike(String value) {
            addCriterion("AUDIT_AGENTID not like", value, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidIn(List<String> values) {
            addCriterion("AUDIT_AGENTID in", values, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidNotIn(List<String> values) {
            addCriterion("AUDIT_AGENTID not in", values, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidBetween(String value1, String value2) {
            addCriterion("AUDIT_AGENTID between", value1, value2, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andAuditAgentidNotBetween(String value1, String value2) {
            addCriterion("AUDIT_AGENTID not between", value1, value2, "auditAgentid");
            return (Criteria) this;
        }

        public Criteria andProfitRatioIsNull() {
            addCriterion("PROFIT_RATIO is null");
            return (Criteria) this;
        }

        public Criteria andProfitRatioIsNotNull() {
            addCriterion("PROFIT_RATIO is not null");
            return (Criteria) this;
        }

        public Criteria andProfitRatioEqualTo(String value) {
            addCriterion("PROFIT_RATIO =", value, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioNotEqualTo(String value) {
            addCriterion("PROFIT_RATIO <>", value, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioGreaterThan(String value) {
            addCriterion("PROFIT_RATIO >", value, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioGreaterThanOrEqualTo(String value) {
            addCriterion("PROFIT_RATIO >=", value, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioLessThan(String value) {
            addCriterion("PROFIT_RATIO <", value, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioLessThanOrEqualTo(String value) {
            addCriterion("PROFIT_RATIO <=", value, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioLike(String value) {
            addCriterion("PROFIT_RATIO like", value, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioNotLike(String value) {
            addCriterion("PROFIT_RATIO not like", value, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioIn(List<String> values) {
            addCriterion("PROFIT_RATIO in", values, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioNotIn(List<String> values) {
            addCriterion("PROFIT_RATIO not in", values, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioBetween(String value1, String value2) {
            addCriterion("PROFIT_RATIO between", value1, value2, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andProfitRatioNotBetween(String value1, String value2) {
            addCriterion("PROFIT_RATIO not between", value1, value2, "profitRatio");
            return (Criteria) this;
        }

        public Criteria andOemPicIdIsNull() {
            addCriterion("OEM_PIC_ID is null");
            return (Criteria) this;
        }

        public Criteria andOemPicIdIsNotNull() {
            addCriterion("OEM_PIC_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOemPicIdEqualTo(String value) {
            addCriterion("OEM_PIC_ID =", value, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdNotEqualTo(String value) {
            addCriterion("OEM_PIC_ID <>", value, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdGreaterThan(String value) {
            addCriterion("OEM_PIC_ID >", value, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdGreaterThanOrEqualTo(String value) {
            addCriterion("OEM_PIC_ID >=", value, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdLessThan(String value) {
            addCriterion("OEM_PIC_ID <", value, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdLessThanOrEqualTo(String value) {
            addCriterion("OEM_PIC_ID <=", value, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdLike(String value) {
            addCriterion("OEM_PIC_ID like", value, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdNotLike(String value) {
            addCriterion("OEM_PIC_ID not like", value, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdIn(List<String> values) {
            addCriterion("OEM_PIC_ID in", values, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdNotIn(List<String> values) {
            addCriterion("OEM_PIC_ID not in", values, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdBetween(String value1, String value2) {
            addCriterion("OEM_PIC_ID between", value1, value2, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOemPicIdNotBetween(String value1, String value2) {
            addCriterion("OEM_PIC_ID not between", value1, value2, "oemPicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdIsNull() {
            addCriterion("OPENING_LICENSE_PIC_ID is null");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdIsNotNull() {
            addCriterion("OPENING_LICENSE_PIC_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdEqualTo(String value) {
            addCriterion("OPENING_LICENSE_PIC_ID =", value, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdNotEqualTo(String value) {
            addCriterion("OPENING_LICENSE_PIC_ID <>", value, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdGreaterThan(String value) {
            addCriterion("OPENING_LICENSE_PIC_ID >", value, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdGreaterThanOrEqualTo(String value) {
            addCriterion("OPENING_LICENSE_PIC_ID >=", value, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdLessThan(String value) {
            addCriterion("OPENING_LICENSE_PIC_ID <", value, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdLessThanOrEqualTo(String value) {
            addCriterion("OPENING_LICENSE_PIC_ID <=", value, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdLike(String value) {
            addCriterion("OPENING_LICENSE_PIC_ID like", value, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdNotLike(String value) {
            addCriterion("OPENING_LICENSE_PIC_ID not like", value, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdIn(List<String> values) {
            addCriterion("OPENING_LICENSE_PIC_ID in", values, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdNotIn(List<String> values) {
            addCriterion("OPENING_LICENSE_PIC_ID not in", values, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdBetween(String value1, String value2) {
            addCriterion("OPENING_LICENSE_PIC_ID between", value1, value2, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andOpeningLicensePicIdNotBetween(String value1, String value2) {
            addCriterion("OPENING_LICENSE_PIC_ID not between", value1, value2, "openingLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdIsNull() {
            addCriterion("BUSINESS_LICENSE_PIC_ID is null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdIsNotNull() {
            addCriterion("BUSINESS_LICENSE_PIC_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdEqualTo(String value) {
            addCriterion("BUSINESS_LICENSE_PIC_ID =", value, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdNotEqualTo(String value) {
            addCriterion("BUSINESS_LICENSE_PIC_ID <>", value, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdGreaterThan(String value) {
            addCriterion("BUSINESS_LICENSE_PIC_ID >", value, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdGreaterThanOrEqualTo(String value) {
            addCriterion("BUSINESS_LICENSE_PIC_ID >=", value, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdLessThan(String value) {
            addCriterion("BUSINESS_LICENSE_PIC_ID <", value, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdLessThanOrEqualTo(String value) {
            addCriterion("BUSINESS_LICENSE_PIC_ID <=", value, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdLike(String value) {
            addCriterion("BUSINESS_LICENSE_PIC_ID like", value, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdNotLike(String value) {
            addCriterion("BUSINESS_LICENSE_PIC_ID not like", value, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdIn(List<String> values) {
            addCriterion("BUSINESS_LICENSE_PIC_ID in", values, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdNotIn(List<String> values) {
            addCriterion("BUSINESS_LICENSE_PIC_ID not in", values, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdBetween(String value1, String value2) {
            addCriterion("BUSINESS_LICENSE_PIC_ID between", value1, value2, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePicIdNotBetween(String value1, String value2) {
            addCriterion("BUSINESS_LICENSE_PIC_ID not between", value1, value2, "businessLicensePicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdIsNull() {
            addCriterion("LEGAL_IDENTITY_PIC_ID is null");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdIsNotNull() {
            addCriterion("LEGAL_IDENTITY_PIC_ID is not null");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdEqualTo(String value) {
            addCriterion("LEGAL_IDENTITY_PIC_ID =", value, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdNotEqualTo(String value) {
            addCriterion("LEGAL_IDENTITY_PIC_ID <>", value, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdGreaterThan(String value) {
            addCriterion("LEGAL_IDENTITY_PIC_ID >", value, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdGreaterThanOrEqualTo(String value) {
            addCriterion("LEGAL_IDENTITY_PIC_ID >=", value, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdLessThan(String value) {
            addCriterion("LEGAL_IDENTITY_PIC_ID <", value, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdLessThanOrEqualTo(String value) {
            addCriterion("LEGAL_IDENTITY_PIC_ID <=", value, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdLike(String value) {
            addCriterion("LEGAL_IDENTITY_PIC_ID like", value, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdNotLike(String value) {
            addCriterion("LEGAL_IDENTITY_PIC_ID not like", value, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdIn(List<String> values) {
            addCriterion("LEGAL_IDENTITY_PIC_ID in", values, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdNotIn(List<String> values) {
            addCriterion("LEGAL_IDENTITY_PIC_ID not in", values, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdBetween(String value1, String value2) {
            addCriterion("LEGAL_IDENTITY_PIC_ID between", value1, value2, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andLegalIdentityPicIdNotBetween(String value1, String value2) {
            addCriterion("LEGAL_IDENTITY_PIC_ID not between", value1, value2, "legalIdentityPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdIsNull() {
            addCriterion("TAX_NO_PIC_ID is null");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdIsNotNull() {
            addCriterion("TAX_NO_PIC_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdEqualTo(String value) {
            addCriterion("TAX_NO_PIC_ID =", value, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdNotEqualTo(String value) {
            addCriterion("TAX_NO_PIC_ID <>", value, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdGreaterThan(String value) {
            addCriterion("TAX_NO_PIC_ID >", value, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdGreaterThanOrEqualTo(String value) {
            addCriterion("TAX_NO_PIC_ID >=", value, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdLessThan(String value) {
            addCriterion("TAX_NO_PIC_ID <", value, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdLessThanOrEqualTo(String value) {
            addCriterion("TAX_NO_PIC_ID <=", value, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdLike(String value) {
            addCriterion("TAX_NO_PIC_ID like", value, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdNotLike(String value) {
            addCriterion("TAX_NO_PIC_ID not like", value, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdIn(List<String> values) {
            addCriterion("TAX_NO_PIC_ID in", values, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdNotIn(List<String> values) {
            addCriterion("TAX_NO_PIC_ID not in", values, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdBetween(String value1, String value2) {
            addCriterion("TAX_NO_PIC_ID between", value1, value2, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andTaxNoPicIdNotBetween(String value1, String value2) {
            addCriterion("TAX_NO_PIC_ID not between", value1, value2, "taxNoPicId");
            return (Criteria) this;
        }

        public Criteria andAgentKeyIsNull() {
            addCriterion("AGENT_KEY is null");
            return (Criteria) this;
        }

        public Criteria andAgentKeyIsNotNull() {
            addCriterion("AGENT_KEY is not null");
            return (Criteria) this;
        }

        public Criteria andAgentKeyEqualTo(String value) {
            addCriterion("AGENT_KEY =", value, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyNotEqualTo(String value) {
            addCriterion("AGENT_KEY <>", value, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyGreaterThan(String value) {
            addCriterion("AGENT_KEY >", value, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_KEY >=", value, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyLessThan(String value) {
            addCriterion("AGENT_KEY <", value, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyLessThanOrEqualTo(String value) {
            addCriterion("AGENT_KEY <=", value, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyLike(String value) {
            addCriterion("AGENT_KEY like", value, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyNotLike(String value) {
            addCriterion("AGENT_KEY not like", value, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyIn(List<String> values) {
            addCriterion("AGENT_KEY in", values, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyNotIn(List<String> values) {
            addCriterion("AGENT_KEY not in", values, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyBetween(String value1, String value2) {
            addCriterion("AGENT_KEY between", value1, value2, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentKeyNotBetween(String value1, String value2) {
            addCriterion("AGENT_KEY not between", value1, value2, "agentKey");
            return (Criteria) this;
        }

        public Criteria andAgentTypeIsNull() {
            addCriterion("AGENT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andAgentTypeIsNotNull() {
            addCriterion("AGENT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andAgentTypeEqualTo(String value) {
            addCriterion("AGENT_TYPE =", value, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeNotEqualTo(String value) {
            addCriterion("AGENT_TYPE <>", value, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeGreaterThan(String value) {
            addCriterion("AGENT_TYPE >", value, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_TYPE >=", value, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeLessThan(String value) {
            addCriterion("AGENT_TYPE <", value, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeLessThanOrEqualTo(String value) {
            addCriterion("AGENT_TYPE <=", value, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeLike(String value) {
            addCriterion("AGENT_TYPE like", value, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeNotLike(String value) {
            addCriterion("AGENT_TYPE not like", value, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeIn(List<String> values) {
            addCriterion("AGENT_TYPE in", values, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeNotIn(List<String> values) {
            addCriterion("AGENT_TYPE not in", values, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeBetween(String value1, String value2) {
            addCriterion("AGENT_TYPE between", value1, value2, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentTypeNotBetween(String value1, String value2) {
            addCriterion("AGENT_TYPE not between", value1, value2, "agentType");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdIsNull() {
            addCriterion("AGENT_CUST_ID is null");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdIsNotNull() {
            addCriterion("AGENT_CUST_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdEqualTo(String value) {
            addCriterion("AGENT_CUST_ID =", value, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdNotEqualTo(String value) {
            addCriterion("AGENT_CUST_ID <>", value, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdGreaterThan(String value) {
            addCriterion("AGENT_CUST_ID >", value, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdGreaterThanOrEqualTo(String value) {
            addCriterion("AGENT_CUST_ID >=", value, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdLessThan(String value) {
            addCriterion("AGENT_CUST_ID <", value, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdLessThanOrEqualTo(String value) {
            addCriterion("AGENT_CUST_ID <=", value, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdLike(String value) {
            addCriterion("AGENT_CUST_ID like", value, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdNotLike(String value) {
            addCriterion("AGENT_CUST_ID not like", value, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdIn(List<String> values) {
            addCriterion("AGENT_CUST_ID in", values, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdNotIn(List<String> values) {
            addCriterion("AGENT_CUST_ID not in", values, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdBetween(String value1, String value2) {
            addCriterion("AGENT_CUST_ID between", value1, value2, "agentCustId");
            return (Criteria) this;
        }

        public Criteria andAgentCustIdNotBetween(String value1, String value2) {
            addCriterion("AGENT_CUST_ID not between", value1, value2, "agentCustId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}